create external table jms_dm.dm_aviation_order_detail_dt (
  `waybill_no` string COMMENT '运单号',
  `collect_time` timestamp COMMENT '揽收时间',
  `operation_date` date COMMENT '发货上报日期',
  `operation_time` timestamp COMMENT '发货上报时间',
  `package_code` string COMMENT '包号',
  `send_scan_time` timestamp COMMENT '航空发件时间',
  `arrive_scan_time` timestamp COMMENT '航空到件时间',
  `pick_network_code` string COMMENT '订单所属网点编码',
  `pick_network_name` string COMMENT '订单所属网点名称',
  `pick_agent_area_name` string COMMENT '订单所属代理区',
  `origin_center_code` string COMMENT '航空始发机构编号',
  `origin_center_name` string COMMENT '航空始发机构名称',
  `origin_agent_area_id` string COMMENT '航空始发代理区ID',
  `origin_agent_area_code` string COMMENT '航空始发代理区编号',
  `origin_agent_area_name` string COMMENT '航空始发代理区',
  `origin_airport` string COMMENT '始发机场',
  `booking_space_no` string COMMENT '订舱号',
  `destination_agent_area_id` string COMMENT '航空目的地代理区ID',
  `destination_agent_area_code` string COMMENT '航空目的地代理区code',
  `destination_agent_area_name` string COMMENT '航空目的地代理区',
  `destination_center_code` string COMMENT '航空目的地机构编号',
  `destination_center_name` string COMMENT '航空目的地机构名称',
  `destination_airport` string COMMENT '目的机场',
  `package_inside_charge_weight` decimal(15,2) COMMENT '内部计费重量',
  `dispatch_time` timestamp COMMENT '派件时间',
  `dispatch_agent_code` string COMMENT '派件代理区编码',
  `dispatch_agent_name` string COMMENT '派件代理区名称',
  `dispatch_network_code` string COMMENT '派件网点编码',
  `dispatch_network_name` string COMMENT '派件网点名称',
  `sender_province_id` string COMMENT '寄件省ID',
  `sender_province_name` string COMMENT '寄件省',
  `sender_city_id` string COMMENT '寄件市ID',
  `sender_city_name` string COMMENT '寄件市',
  `sender_area_id` string COMMENT '寄件区ID',
  `sender_area_name` string COMMENT '寄件区',
  `receiver_province_id` string COMMENT '目的省ID',
  `receiver_province_name` string COMMENT '目的省',
  `receiver_city_id` string COMMENT '目的市ID',
  `receiver_city_name` string COMMENT '目的市',
  `receiver_area_id` string COMMENT '目的区ID',
  `receiver_area_name` string COMMENT '目的区',
  `plan_cainiao_platform_date` timestamp COMMENT '菜鸟规划应签收日期',
  `cainiao_platform_effect` bigint COMMENT '菜鸟平台时效',
  `is_pres_sign` bigint COMMENT '时效签收'
)
comment '航空订单明细'
partitioned by (dt string comment '发货上报日期分区')
stored as parquet
location '/dw/hive/jms_dm.db/external/dm_aviation_order_detail_dt'
;



